Formulation of Least-Cost Dairy Ration for Small-Scale Dairy Farms Using ‘Solver Add-Ins’ in Microsoft Excel

Authors

  • G.B. Das Department of Animal Science and Nutrition, Faculty of Veterinary Medicine, Chittagong Veterinary and Animal Science University, Khulshi, Chittagong, Bangladesh
  • M.A. Akbar Department of Animal Nutrition, Faculty of Animal Husbandry, Bangladesh Agricultural University, Mymensingh, Bangladesh
  • M.E. Hossain Department of Animal Science and Nutrition, Faculty of Veterinary Medicine, Chittagong Veterinary and Animal Science University, Khulshi, Chittagong, Bangladesh
Abstract:

Small-scale dairy farming in Bangladesh is constrained mostly due to acute shortage, high price and seasonal fluctuation of energy and protein supplements. Poor economic conditions of dairy farmers do not allow them to purchase adequate conventional energy and protein supplements. Locally available non-conventional energy and protein sources can be used as alternatives, cheaper than conventional energy and protein sources. Non-conventional feedstuffs are deficient in certain macro and micro nutrients. As a result, formulation of a least-cost balanced ration using non-conventional feedstuffs is a major challenge for marginal farmers. The current study presents a least-cost formulation plan for the small-scale dairy farmers using locally available low-cost non-conventional feedstuffs. A simple Microsoft Excel program with ‘Solver Add-ins’ has been used to formulate least-cost rations for crossbred and indigenous dairy cows. The step by step logical procedure ensured that the ration was balanced for most of the key nutrients, was least-cost and gave the user significant control over the formulation process. Incorporation of multipurpose low cost neglected forages such as water hyacinth (Eichhornia crassipes), helencha (Enhydra fluctuans), ipil-ipil (Leucaena leucocephala) and their subsequent effect on cost minimization is discussed. This formulation method may be recommended for use by small-scale dairy farmers as well as livestock extension workers who wish to formulate least-cost dairy rations using locally available feed sources to optimize the feeding of dairy animals at farm level.

Upgrade to premium to download articles

Sign up to access the full text

Already have an account?login

similar resources

formulation of least-cost dairy ration for small-scale dairy farms using ‘solver add-ins’ in microsoft excel

small-scale dairy farming in bangladesh is constrained mostly due to acute shortage, high price and seasonal fluctuation of energy and protein supplements. poor economic conditions of dairy farmers do not allow them to purchase adequate conventional energy and protein supplements. locally available non-conventional energy and protein sources can be used as alternatives, cheaper than conventiona...

full text

Using Distillers Grains in the Dairy Ration

The feeding of distillers grains to dairy cattle is nothing new; such products have been fed cattle for more than a century. The research article by Loosli et al. (1952) referenced an 1895 Vermont Agricultural Experiment Station Bulletin that reported on the feeding of distillers grains to lactating cows. In many respects, one might say that responses to feeding distillers grains today should b...

full text

Economic Opportunity Survey of Small Dairy Farms in the Southwest Part of Iran

In this study 495 smallholder dairy farms in 52 villages of different township in southwestern province of Iran (Chaharmohal and Bakhtiari province) included 1321 lactating cows and 2811 total mature cows (lactating and dry) during winter 2009 to summer 2010 were used to estimate economic opportunities insmallholder dairy farms. Questionnaire survey was used to collect data from last year infor...

full text

Economics of Fertility Management of Small Holding Dairy Farms in Bangladesh

Considering different fertility traits 411 cows from 73 farms used for economic analyses. From these, 202 lactating cows were selected for evaluating the fertility status. Pre-tested data sheets were used to record the socioeconomic status of the farms including their assets, cost and return and productive and reproductive performance of the dairy cows. Targets were set considering the situatio...

full text

Ration Balancing : New Advances in Dairy Research

As advances in dairy cattle nutrition research are now becoming available to the dairy industry, it is sometimes difficult to understand how these differ ent advances and improvements in our understanding of dairy nutrition with the different approaches taken by different companies and their associated “jargon”. This brochure is meant as a general overview of the different ration balancing syst...

full text

My Resources

Save resource for easier access later

Save to my library Already added to my library

{@ msg_add @}


Journal title

volume 5  issue 3

pages  561- 567

publication date 2015-09-01

By following a journal you will be notified via email when a new issue of this journal is published.

Hosted on Doprax cloud platform doprax.com

copyright © 2015-2023